Accidents

Dataset statistics

Number of variables	33
Number of observations	867550
Missing cells	1280777
Missing cells (%)	4.5%
Duplicate rows	2
Duplicate rows (%)	< 0.1%
Total size in memory	218.4 MiB
Average record size in memory	264.0 B

Variable types

Categorical	16
Numeric	15
Unsupported	1
Boolean	1

Alerts

Dataset has 2 (< 0.1%) duplicate rows	Duplicates
`Accident_Index` has a high cardinality: 558085 distinct values	High cardinality
`Date` has a high cardinality: 2190 distinct values	High cardinality
`Time` has a high cardinality: 1439 distinct values	High cardinality
`Local_Authority_(Highway)` has a high cardinality: 207 distinct values	High cardinality
`LSOA_of_Accident_Location` has a high cardinality: 34140 distinct values	High cardinality
`Location_Easting_OSGR` is highly correlated with `Longitude`	High correlation
`Location_Northing_OSGR` is highly correlated with `Latitude`	High correlation
`Longitude` is highly correlated with `Location_Easting_OSGR`	High correlation
`Latitude` is highly correlated with `Location_Northing_OSGR`	High correlation
`Police_Force` is highly correlated with `Local_Authority_(District)`	High correlation
`Local_Authority_(District)` is highly correlated with `Police_Force`	High correlation
`Speed_limit` is highly correlated with `Urban_or_Rural_Area`	High correlation
`Urban_or_Rural_Area` is highly correlated with `Speed_limit`	High correlation
`Location_Easting_OSGR` is highly correlated with `Longitude`	High correlation
`Location_Northing_OSGR` is highly correlated with `Latitude`	High correlation
`Longitude` is highly correlated with `Location_Easting_OSGR`	High correlation
`Latitude` is highly correlated with `Location_Northing_OSGR`	High correlation
`Police_Force` is highly correlated with `Local_Authority_(District)`	High correlation
`Local_Authority_(District)` is highly correlated with `Police_Force`	High correlation
`Speed_limit` is highly correlated with `Urban_or_Rural_Area`	High correlation
`Urban_or_Rural_Area` is highly correlated with `Speed_limit`	High correlation
`Location_Easting_OSGR` is highly correlated with `Longitude`	High correlation
`Location_Northing_OSGR` is highly correlated with `Latitude`	High correlation
`Longitude` is highly correlated with `Location_Easting_OSGR`	High correlation
`Latitude` is highly correlated with `Location_Northing_OSGR`	High correlation
`Police_Force` is highly correlated with `Local_Authority_(District)`	High correlation
`Local_Authority_(District)` is highly correlated with `Police_Force`	High correlation
`Speed_limit` is highly correlated with `Urban_or_Rural_Area`	High correlation
`Urban_or_Rural_Area` is highly correlated with `Speed_limit`	High correlation
`Location_Easting_OSGR` is highly correlated with `Location_Northing_OSGR` and 4 other fields	High correlation
`Location_Northing_OSGR` is highly correlated with `Location_Easting_OSGR` and 4 other fields	High correlation
`Longitude` is highly correlated with `Location_Easting_OSGR` and 4 other fields	High correlation
`Latitude` is highly correlated with `Location_Easting_OSGR` and 4 other fields	High correlation
`Police_Force` is highly correlated with `Location_Easting_OSGR` and 4 other fields	High correlation
`Local_Authority_(District)` is highly correlated with `Location_Easting_OSGR` and 4 other fields	High correlation
`1st_Road_Class` is highly correlated with `Road_Type` and 1 other fields	High correlation
`1st_Road_Number` is highly correlated with `2nd_Road_Number`	High correlation
`Road_Type` is highly correlated with `1st_Road_Class`	High correlation
`Speed_limit` is highly correlated with `1st_Road_Class` and 1 other fields	High correlation
`Junction_Control` is highly correlated with `Pedestrian_Crossing-Physical_Facilities`	High correlation
`2nd_Road_Number` is highly correlated with `1st_Road_Number`	High correlation
`Pedestrian_Crossing-Physical_Facilities` is highly correlated with `Junction_Control`	High correlation
`Weather_Conditions` is highly correlated with `Road_Surface_Conditions`	High correlation
`Road_Surface_Conditions` is highly correlated with `Weather_Conditions`	High correlation
`Urban_or_Rural_Area` is highly correlated with `Speed_limit`	High correlation
`Junction_Detail` has 867550 (100.0%) missing values	Missing
`Junction_Control` has 350857 (40.4%) missing values	Missing
`LSOA_of_Accident_Location` has 58613 (6.8%) missing values	Missing
`Junction_Detail` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`1st_Road_Number` has 236889 (27.3%) zeros	Zeros
`2nd_Road_Number` has 669484 (77.2%) zeros	Zeros

Reproduction

Analysis started	2022-01-09 14:09:31.884097
Analysis finished	2022-01-09 14:17:04.640856
Duration	7 minutes and 32.76 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Accident_Index
Categorical

HIGH CARDINALITY

Distinct	558085
Distinct (%)	64.3%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

2.01E+12	137503
2.00913E+12	6255
2.01013E+12	5760
2.01113E+12	5402
2.00946E+12	5158
Other values (558080)	707472

Length

Max length	255
Median length	13
Mean length	11.82327474
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	557880 ?
Unique (%)	64.3%

Sample

1st row	200901BS70001
2nd row	200901BS70002
3rd row	200901BS70003
4th row	200901BS70004
5th row	200901BS70005

Common Values

Value	Count	Frequency (%)
2.01E+12	137503	15.8%
2.00913E+12	6255	0.7%
2.01013E+12	5760	0.7%
2.01113E+12	5402	0.6%
2.00946E+12	5158	0.6%
2.01144E+12	5000	0.6%
2.01146E+12	4867	0.6%
2.01046E+12	4837	0.6%
2.01044E+12	4809	0.6%
2.00944E+12	4683	0.5%
Other values (558075)	683276	78.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2.01e+12	137503	15.8%
2.00913e+12	6255	0.7%
2.01013e+12	5760	0.7%
2.01113e+12	5402	0.6%
2.00946e+12	5158	0.6%
2.01144e+12	5000	0.6%
2.01146e+12	4867	0.6%
2.01046e+12	4837	0.6%
2.01044e+12	4809	0.6%
2.00944e+12	4683	0.5%
Other values (558075)	683276	78.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Location_Easting_OSGR
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	60961
Distinct (%)	7.0%
Missing	86
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	439345.3646

Minimum	64950
Maximum	655370
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	64950
5-th percentile	263690
Q1	375220
median	439790
Q3	523520
95-th percentile	577090
Maximum	655370
Range	590420
Interquartile range (IQR)	148300

Descriptive statistics

Standard deviation	95453.94719
Coefficient of variation (CV)	0.2172640362
Kurtosis	-0.4165415443
Mean	439345.3646
Median Absolute Deviation (MAD)	77234.5
Skewness	-0.3256436201
Sum	3.811162873 × 10¹¹
Variance	9111456034
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
533650	222	< 0.1%
531170	201	< 0.1%
531180	177	< 0.1%
530980	169	< 0.1%
533470	159	< 0.1%
532440	157	< 0.1%
530020	156	< 0.1%
529210	156	< 0.1%
534950	150	< 0.1%
531000	149	< 0.1%
Other values (60951)	865768	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
64950	1	< 0.1%
65350	1	< 0.1%
65670	1	< 0.1%
65690	1	< 0.1%
65860	1	< 0.1%
65950	1	< 0.1%
66710	1	< 0.1%
68290	1	< 0.1%
68880	1	< 0.1%
73760	1	< 0.1%

Value	Count	Frequency (%)
655370	2	< 0.1%
655290	1	< 0.1%
655280	2	< 0.1%
655230	2	< 0.1%
655180	1	< 0.1%
655160	1	< 0.1%
655150	2	< 0.1%
655140	1	< 0.1%
655120	4	< 0.1%
655110	5	< 0.1%

Location_Northing_OSGR
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	84093
Distinct (%)	9.7%
Missing	86
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	299358.2346

Minimum	10520
Maximum	1205100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	10520
5-th percentile	104210
Q1	178530
median	266360
Q3	396920
95-th percentile	662830
Maximum	1205100
Range	1194580
Interquartile range (IQR)	218390

Descriptive statistics

Standard deviation	161335.2572
Coefficient of variation (CV)	0.5389370947
Kurtosis	0.8529571153
Mean	299358.2346
Median Absolute Deviation (MAD)	98140
Skewness	1.028136542
Sum	2.596824917 × 10¹¹
Variance	2.602906523 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
181310	237	< 0.1%
181170	205	< 0.1%
181110	192	< 0.1%
179660	188	< 0.1%
181060	184	< 0.1%
181050	179	< 0.1%
178620	179	< 0.1%
181120	175	< 0.1%
180820	170	< 0.1%
181370	170	< 0.1%
Other values (84083)	865585	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10520	1	< 0.1%
10530	2	< 0.1%
10560	1	< 0.1%
10650	1	< 0.1%
10670	1	< 0.1%
10840	1	< 0.1%
10860	1	< 0.1%
11100	1	< 0.1%
11620	1	< 0.1%
12460	1	< 0.1%

Value	Count	Frequency (%)
1205100	1	< 0.1%
1203900	1	< 0.1%
1198000	1	< 0.1%
1191700	1	< 0.1%
1191500	1	< 0.1%
1191030	1	< 0.1%
1189600	1	< 0.1%
1186100	1	< 0.1%
1183830	1	< 0.1%
1178600	1	< 0.1%

Longitude
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	665752
Distinct (%)	76.7%
Missing	86
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-1.440834649

Minimum	-7.516225
Maximum	1.759398
Zeros	0
Zeros (%)	0.0%
Negative	755392
Negative (%)	87.1%
Memory size	6.6 MiB

Quantile statistics

Minimum	-7.516225
5-th percentile	-4.0650028
Q1	-2.37124325
median	-1.405855
Q3	-0.2147575
95-th percentile	0.54888005
Maximum	1.759398
Range	9.275623
Interquartile range (IQR)	2.15648575

Descriptive statistics

Standard deviation	1.403280097
Coefficient of variation (CV)	-0.9739355579
Kurtosis	-0.3706435719
Mean	-1.440834649
Median Absolute Deviation (MAD)	1.117442
Skewness	-0.3658417901
Sum	-1249872.188
Variance	1.969195031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-3.310596	43	< 0.1%
-0.977611	42	< 0.1%
-3.241694	38	< 0.1%
-1.234393	33	< 0.1%
-1.871043	31	< 0.1%
-1.216694	30	< 0.1%
-0.173445	30	< 0.1%
-1.999967	29	< 0.1%
-1.265368	29	< 0.1%
-0.115063	29	< 0.1%
Other values (665742)	867130	> 99.9%
(Missing)	86	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-7.516225	1	< 0.1%
-7.507468	1	< 0.1%
-7.507207	1	< 0.1%
-7.504121	1	< 0.1%
-7.498973	1	< 0.1%
-7.497461	1	< 0.1%
-7.49183	1	< 0.1%
-7.465609	1	< 0.1%
-7.460259	1	< 0.1%
-7.450015	1	< 0.1%

Value	Count	Frequency (%)
1.759398	1	< 0.1%
1.759382	1	< 0.1%
1.758337	1	< 0.1%
1.75819	1	< 0.1%
1.758106	1	< 0.1%
1.757915	1	< 0.1%
1.757907	1	< 0.1%
1.75651	1	< 0.1%
1.75643	1	< 0.1%
1.756347	1	< 0.1%

Latitude
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	638427
Distinct (%)	73.6%
Missing	86
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	52.58216458

Minimum	49.914488
Maximum	60.724682
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	49.914488
5-th percentile	50.824713
Q1	51.49274875
median	52.2885245
Q3	53.4673965
95-th percentile	55.838885
Maximum	60.724682
Range	10.810194
Interquartile range (IQR)	1.97464775

Descriptive statistics

Standard deviation	1.452734597
Coefficient of variation (CV)	0.02762789644
Kurtosis	0.8237475072
Mean	52.58216458
Median Absolute Deviation (MAD)	0.889849
Skewness	1.019095565
Sum	45613134.81
Variance	2.110437811
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51.506693	44	< 0.1%
52.949719	42	< 0.1%
52.458798	40	< 0.1%
51.526956	38	< 0.1%
52.989857	33	< 0.1%
51.560108	32	< 0.1%
51.482076	32	< 0.1%
52.955058	30	< 0.1%
53.792423	30	< 0.1%
52.93886	30	< 0.1%
Other values (638417)	867113	99.9%
(Missing)	86	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
49.914488	1	< 0.1%
49.914513	1	< 0.1%
49.914701	1	< 0.1%
49.914804	1	< 0.1%
49.91573	1	< 0.1%
49.915987	1	< 0.1%
49.917703	1	< 0.1%
49.917913	1	< 0.1%
49.920895	1	< 0.1%
49.925225	1	< 0.1%

Value	Count	Frequency (%)
60.724682	1	< 0.1%
60.714774	1	< 0.1%
60.662043	1	< 0.1%
60.605743	1	< 0.1%
60.604117	1	< 0.1%
60.598055	1	< 0.1%
60.586586	1	< 0.1%
60.555234	1	< 0.1%
60.535623	1	< 0.1%
60.48982	1	< 0.1%

Police_Force
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.53854533

Minimum	1
Maximum	98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	7
median	30
Q3	46
95-th percentile	94
Maximum	98
Range	97
Interquartile range (IQR)	39

Descriptive statistics

Standard deviation	25.63716814
Coefficient of variation (CV)	0.839501943
Kurtosis	0.308705958
Mean	30.53854533
Median Absolute Deviation (MAD)	18
Skewness	0.8503239169
Sum	26493715
Variance	657.2643903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	131752	15.2%
20	36445	4.2%
6	34731	4.0%
13	31857	3.7%
43	31680	3.7%
44	25852	3.0%
46	25749	3.0%
50	24890	2.9%
97	24442	2.8%
4	24022	2.8%
Other values (41)	476130	54.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	131752	15.2%
3	7617	0.9%
4	24022	2.8%
5	18625	2.1%
6	34731	4.0%
7	16838	1.9%
10	20033	2.3%
11	7922	0.9%
12	11790	1.4%
13	31857	3.7%

Value	Count	Frequency (%)
98	2000	0.2%
97	24442	2.8%
96	2988	0.3%
95	12299	1.4%
94	2967	0.3%
93	4382	0.5%
92	5721	0.7%
91	3384	0.4%
63	7956	0.9%
62	15966	1.8%

Accident_Severity
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

3	741295
2	114777
1	11478

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	3
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
3	741295	85.4%
2	114777	13.2%
1	11478	1.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
3	741295	85.4%
2	114777	13.2%
1	11478	1.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Number_of_Vehicles
Real number (ℝ_≥0)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.831130194

Minimum	1
Maximum	34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	34
Range	33
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7152484902
Coefficient of variation (CV)	0.3906049349
Kurtosis	22.46128485
Mean	1.831130194
Median Absolute Deviation (MAD)	0
Skewness	1.883800766
Sum	1588597
Variance	0.5115804028
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
2	514099	59.3%
1	263876	30.4%
3	69977	8.1%
4	14614	1.7%
5	3281	0.4%
6	1019	0.1%
7	346	< 0.1%
8	165	< 0.1%
9	87	< 0.1%
10	31	< 0.1%
Other values (14)	55	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	263876	30.4%
2	514099	59.3%
3	69977	8.1%
4	14614	1.7%
5	3281	0.4%
6	1019	0.1%
7	346	< 0.1%
8	165	< 0.1%
9	87	< 0.1%
10	31	< 0.1%

Value	Count	Frequency (%)
34	1	< 0.1%
32	1	< 0.1%
29	1	< 0.1%
22	1	< 0.1%
20	2	< 0.1%
19	1	< 0.1%
18	2	< 0.1%
17	1	< 0.1%
16	2	< 0.1%
15	2	< 0.1%

Number_of_Casualties
Real number (ℝ_≥0)

Distinct	39
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.355902253

Minimum	1
Maximum	87
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	87
Range	86
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8227544818
Coefficient of variation (CV)	0.6067948333
Kurtosis	304.8817278
Mean	1.355902253
Median Absolute Deviation (MAD)	0
Skewness	7.439683896
Sum	1176313
Variance	0.6769249374
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
1	662552	76.4%
2	141269	16.3%
3	40173	4.6%
4	14757	1.7%
5	5351	0.6%
6	2032	0.2%
7	700	0.1%
8	301	< 0.1%
9	132	< 0.1%
10	83	< 0.1%
Other values (29)	200	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	662552	76.4%
2	141269	16.3%
3	40173	4.6%
4	14757	1.7%
5	5351	0.6%
6	2032	0.2%
7	700	0.1%
8	301	< 0.1%
9	132	< 0.1%
10	83	< 0.1%

Value	Count	Frequency (%)
87	1	< 0.1%
63	1	< 0.1%
51	2	< 0.1%
48	1	< 0.1%
45	1	< 0.1%
43	2	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
40	1	< 0.1%
36	2	< 0.1%

Date
Categorical

HIGH CARDINALITY

Distinct	2190
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

21/10/2005	822
18/11/2005	787
29/09/2006	784
22/09/2006	780
7/12/2005	775
Other values (2185)	863602

Length

Max length	10
Median length	10
Mean length	9.413184255
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1/1/2009
2nd row	5/1/2009
3rd row	4/1/2009
4th row	5/1/2009
5th row	6/1/2009

Common Values

Value	Count	Frequency (%)
21/10/2005	822	0.1%
18/11/2005	787	0.1%
29/09/2006	784	0.1%
22/09/2006	780	0.1%
7/12/2005	775	0.1%
1/12/2006	750	0.1%
30/09/2005	749	0.1%
9/12/2005	748	0.1%
12/10/2005	746	0.1%
19/12/2005	744	0.1%
Other values (2180)	859865	99.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
21/10/2005	822	0.1%
18/11/2005	787	0.1%
29/09/2006	784	0.1%
22/09/2006	780	0.1%
7/12/2005	775	0.1%
1/12/2006	750	0.1%
30/09/2005	749	0.1%
9/12/2005	748	0.1%
12/10/2005	746	0.1%
6/10/2006	744	0.1%
Other values (2180)	859865	99.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Day_of_Week
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.126450349

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.926804174
Coefficient of variation (CV)	0.4669398663
Kurtosis	-1.188983492
Mean	4.126450349
Median Absolute Deviation (MAD)	2
Skewness	-0.07424872214
Sum	3579902
Variance	3.712574326
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
6	143407	16.5%
4	130810	15.1%
5	130039	15.0%
3	128417	14.8%
2	122253	14.1%
7	117274	13.5%
1	95350	11.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	95350	11.0%
2	122253	14.1%
3	128417	14.8%
4	130810	15.1%
5	130039	15.0%
6	143407	16.5%
7	117274	13.5%

Value	Count	Frequency (%)
7	117274	13.5%
6	143407	16.5%
5	130039	15.0%
4	130810	15.1%
3	128417	14.8%
2	122253	14.1%
1	95350	11.0%

Time
Categorical

HIGH CARDINALITY

Distinct	1439
Distinct (%)	0.2%
Missing	84
Missing (%)	< 0.1%
Memory size	6.6 MiB

17:00	8531
17:30	8034
16:00	7722
15:30	7684
18:00	7620
Other values (1434)	827875

Length

Max length	5
Median length	5
Mean length	4.764025334
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	15:11
2nd row	10:59
3rd row	14:19
4th row	8:10
5th row	17:25

Common Values

Value	Count	Frequency (%)
17:00	8531	1.0%
17:30	8034	0.9%
16:00	7722	0.9%
15:30	7684	0.9%
18:00	7620	0.9%
16:30	7413	0.9%
15:00	6776	0.8%
8:30	6774	0.8%
14:00	6220	0.7%
13:00	6205	0.7%
Other values (1429)	794487	91.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
17:00	8531	1.0%
17:30	8034	0.9%
16:00	7722	0.9%
15:30	7684	0.9%
18:00	7620	0.9%
16:30	7413	0.9%
15:00	6776	0.8%
8:30	6774	0.8%
14:00	6220	0.7%
13:00	6205	0.7%
Other values (1429)	794487	91.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Local_Authority_(District)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	416
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	350.8887787

Minimum	1
Maximum	941
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	112
median	323
Q3	531
95-th percentile	919
Maximum	941
Range	940
Interquartile range (IQR)	419

Descriptive statistics

Standard deviation	260.5982614
Coefficient of variation (CV)	0.7426805221
Kurtosis	-0.5253929141
Mean	350.8887787
Median Absolute Deviation (MAD)	209
Skewness	0.5124034513
Sum	304413560
Variance	67911.45385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300	16566	1.9%
204	11304	1.3%
102	8873	1.0%
1	8861	1.0%
926	7944	0.9%
200	7829	0.9%
91	7564	0.9%
215	7453	0.9%
9	6522	0.8%
923	6401	0.7%
Other values (406)	778233	89.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8861	1.0%
2	4940	0.6%
3	4127	0.5%
4	4806	0.6%
5	4954	0.6%
6	3701	0.4%
7	4298	0.5%
8	5328	0.6%
9	6522	0.8%
10	4323	0.5%

Value	Count	Frequency (%)
941	190	< 0.1%
940	2134	0.2%
939	1229	0.1%
938	3079	0.4%
937	1230	0.1%
936	195	< 0.1%
935	1900	0.2%
934	1821	0.2%
933	147	< 0.1%
932	3352	0.4%

Local_Authority_(Highway)
Categorical

HIGH CARDINALITY

Distinct	207
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

E10000016	22579
E10000030	21430
E10000017	19282
E10000012	18446
E10000014	17107
Other values (202)	768706

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	E09000020
2nd row	E09000020
3rd row	E09000020
4th row	E09000020
5th row	E09000020

Common Values

Value	Count	Frequency (%)
E10000016	22579	2.6%
E10000030	21430	2.5%
E10000017	19282	2.2%
E10000012	18446	2.1%
E10000014	17107	2.0%
E08000025	16566	1.9%
E10000015	15744	1.8%
E10000028	13659	1.6%
E10000019	12099	1.4%
E10000024	11668	1.3%
Other values (197)	698970	80.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
e10000016	22579	2.6%
e10000030	21430	2.5%
e10000017	19282	2.2%
e10000012	18446	2.1%
e10000014	17107	2.0%
e08000025	16566	1.9%
e10000015	15744	1.8%
e10000028	13659	1.6%
e10000019	12099	1.4%
e10000024	11668	1.3%
Other values (197)	698970	80.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

1st_Road_Class
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.091393003

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	3
median	4
Q3	6
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.431849803
Coefficient of variation (CV)	0.3499663322
Kurtosis	-1.063104444
Mean	4.091393003
Median Absolute Deviation (MAD)	1
Skewness	0.1056560506
Sum	3549488
Variance	2.050193858
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	393461	45.4%
6	250413	28.9%
4	109910	12.7%
5	77749	9.0%
1	33792	3.9%
2	2225	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	33792	3.9%
2	2225	0.3%
3	393461	45.4%
4	109910	12.7%
5	77749	9.0%
6	250413	28.9%

Value	Count	Frequency (%)
6	250413	28.9%
5	77749	9.0%
4	109910	12.7%
3	393461	45.4%
2	2225	0.3%
1	33792	3.9%

1st_Road_Number
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	6329
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1002.772014

Minimum	-1
Maximum	9999
Zeros	236889
Zeros (%)	27.3%
Negative	2
Negative (%)	< 0.1%
Memory size	6.6 MiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	124
Q3	709
95-th percentile	5305
Maximum	9999
Range	10000
Interquartile range (IQR)	709

Descriptive statistics

Standard deviation	1822.998663
Coefficient of variation (CV)	1.817959254
Kurtosis	3.400867697
Mean	1002.772014
Median Absolute Deviation (MAD)	124
Skewness	2.085518023
Sum	869954861
Variance	3323324.127
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	236889	27.3%
1	11247	1.3%
6	9533	1.1%
4	8273	1.0%
25	5892	0.7%
5	5743	0.7%
40	5632	0.6%
38	5198	0.6%
3	4957	0.6%
23	4372	0.5%
Other values (6319)	569814	65.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	2	< 0.1%
0	236889	27.3%
1	11247	1.3%
2	3796	0.4%
3	4957	0.6%
4	8273	1.0%
5	5743	0.7%
6	9533	1.1%
7	1048	0.1%
8	2483	0.3%

Value	Count	Frequency (%)
9999	172	< 0.1%
9963	1	< 0.1%
9962	1	< 0.1%
9950	1	< 0.1%
9910	1	< 0.1%
9875	2	< 0.1%
9855	1	< 0.1%
9854	1	< 0.1%
9853	1	< 0.1%
9840	2	< 0.1%

Road_Type
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

Single carriageway	648718
Dual carriageway	128858
Roundabout	57246
One way street	18528
Slip road	8932

Length

Max length	18
Median length	18
Mean length	16.93016887
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	One way street
2nd row	Single carriageway
3rd row	Single carriageway
4th row	Single carriageway
5th row	Single carriageway

Common Values

Value	Count	Frequency (%)
Single carriageway	648718	74.8%
Dual carriageway	128858	14.9%
Roundabout	57246	6.6%
One way street	18528	2.1%
Slip road	8932	1.0%
Unknown	5268	0.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
carriageway	777576	46.0%
single	648718	38.4%
dual	128858	7.6%
roundabout	57246	3.4%
one	18528	1.1%
way	18528	1.1%
street	18528	1.1%
slip	8932	0.5%
road	8932	0.5%
unknown	5268	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Speed_limit
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.16950608

Minimum	10
Maximum	70
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	10
5-th percentile	30
Q1	30
median	30
Q3	50
95-th percentile	70
Maximum	70
Range	60
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	14.19067928
Coefficient of variation (CV)	0.3622889514
Kurtosis	-0.4574719998
Mean	39.16950608
Median Absolute Deviation (MAD)	0
Skewness	1.088795917
Sum	33981505
Variance	201.3753785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
30	558871	64.4%
60	141734	16.3%
40	69886	8.1%
70	63639	7.3%
50	26430	3.0%
20	6973	0.8%
10	10	< 0.1%
15	7	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	10	< 0.1%
15	7	< 0.1%
20	6973	0.8%
30	558871	64.4%
40	69886	8.1%
50	26430	3.0%
60	141734	16.3%
70	63639	7.3%

Value	Count	Frequency (%)
70	63639	7.3%
60	141734	16.3%
50	26430	3.0%
40	69886	8.1%
30	558871	64.4%
20	6973	0.8%
15	7	< 0.1%
10	10	< 0.1%

Junction_Detail
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	867550
Missing (%)	100.0%
Memory size	6.6 MiB

Junction_Control
Categorical

HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	350857
Missing (%)	40.4%
Memory size	6.6 MiB

Giveway or uncontrolled	419677
Automatic traffic signal	89956
Stop Sign	5572
Authorised person	1488

Length

Max length	24
Median length	23
Mean length	23.00584486
Min length	9

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Giveway or uncontrolled
2nd row	Giveway or uncontrolled
3rd row	Giveway or uncontrolled
4th row	Automatic traffic signal
5th row	Automatic traffic signal

Common Values

Value	Count	Frequency (%)
Giveway or uncontrolled	419677	48.4%
Automatic traffic signal	89956	10.4%
Stop Sign	5572	0.6%
Authorised person	1488	0.2%
(Missing)	350857	40.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
giveway	419677	27.2%
or	419677	27.2%
uncontrolled	419677	27.2%
automatic	89956	5.8%
traffic	89956	5.8%
signal	89956	5.8%
stop	5572	0.4%
sign	5572	0.4%
authorised	1488	0.1%
person	1488	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

2nd_Road_Class
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.642198144

Minimum	-1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	358733
Negative (%)	41.4%
Memory size	6.6 MiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	3
Q3	6
95-th percentile	6
Maximum	6
Range	7
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.205662107
Coefficient of variation (CV)	1.213255756
Kurtosis	-1.822779175
Mean	2.642198144
Median Absolute Deviation (MAD)	3
Skewness	-0.1343789554
Sum	2292239
Variance	10.27626955
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
-1	358733	41.4%
6	340699	39.3%
3	87176	10.0%
5	40535	4.7%
4	33825	3.9%
1	5889	0.7%
2	693	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	358733	41.4%
1	5889	0.7%
2	693	0.1%
3	87176	10.0%
4	33825	3.9%
5	40535	4.7%
6	340699	39.3%

Value	Count	Frequency (%)
6	340699	39.3%
5	40535	4.7%
4	33825	3.9%
3	87176	10.0%
2	693	0.1%
1	5889	0.7%
-1	358733	41.4%

2nd_Road_Number
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	6670
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	381.5278935

Minimum	-1
Maximum	9999
Zeros	669484
Zeros (%)	77.2%
Negative	9152
Negative (%)	1.1%
Memory size	6.6 MiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3408
Maximum	9999
Range	10000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1305.163869
Coefficient of variation (CV)	3.420887153
Kurtosis	17.0034429
Mean	381.5278935
Median Absolute Deviation (MAD)	0
Skewness	4.095138019
Sum	330994524
Variance	1703452.725
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	669484	77.2%
-1	9152	1.1%
1	2119	0.2%
4	1713	0.2%
6	1675	0.2%
40	1219	0.1%
5	1084	0.1%
3	1075	0.1%
38	1050	0.1%
7201	1042	0.1%
Other values (6660)	177937	20.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	9152	1.1%
0	669484	77.2%
1	2119	0.2%
2	576	0.1%
3	1075	0.1%
4	1713	0.2%
5	1084	0.1%
6	1675	0.2%
7	197	< 0.1%
8	517	0.1%

Value	Count	Frequency (%)
9999	386	< 0.1%
9965	1	< 0.1%
9962	1	< 0.1%
9932	1	< 0.1%
9931	1	< 0.1%
9898	1	< 0.1%
9874	1	< 0.1%
9862	1	< 0.1%
9838	1	< 0.1%
9832	3	< 0.1%

Pedestrian_Crossing-Human_Control
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	17
Missing (%)	< 0.1%
Memory size	6.6 MiB

None within 50 metres	862339
Control by other authorised person	3084
Control by school crossing patrol	2110

Length

Max length	34
Median length	21
Mean length	21.07540001
Min length	21

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None within 50 metres
2nd row	None within 50 metres
3rd row	None within 50 metres
4th row	None within 50 metres
5th row	None within 50 metres

Common Values

Value	Count	Frequency (%)
None within 50 metres	862339	99.4%
Control by other authorised person	3084	0.4%
Control by school crossing patrol	2110	0.2%
(Missing)	17	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
none	862339	24.8%
within	862339	24.8%
50	862339	24.8%
metres	862339	24.8%
control	5194	0.1%
by	5194	0.1%
other	3084	0.1%
authorised	3084	0.1%
person	3084	0.1%
school	2110	0.1%
Other values (2)	4220	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Pedestrian_Crossing-Physical_Facilities
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	32
Missing (%)	< 0.1%
Memory size	6.6 MiB

No physical crossing within 50 meters	726922
Pedestrian phase at traffic signal junction	56776
non-junction pedestrian crossing	44229
Zebra crossing	22689
Central refuge	14530

Length

Max length	43
Median length	37
Mean length	36.10451426
Min length	14

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No physical crossing within 50 meters
2nd row	Zebra crossing
3rd row	No physical crossing within 50 meters
4th row	Pedestrian phase at traffic signal junction
5th row	No physical crossing within 50 meters

Common Values

Value	Count	Frequency (%)
No physical crossing within 50 meters	726922	83.8%
Pedestrian phase at traffic signal junction	56776	6.5%
non-junction pedestrian crossing	44229	5.1%
Zebra crossing	22689	2.6%
Central refuge	14530	1.7%
Footbridge or subway	2372	0.3%
(Missing)	32	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
crossing	793840	16.1%
no	726922	14.8%
physical	726922	14.8%
within	726922	14.8%
50	726922	14.8%
meters	726922	14.8%
pedestrian	101005	2.1%
junction	56776	1.2%
signal	56776	1.2%
traffic	56776	1.2%
Other values (9)	216646	4.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Light_Conditions
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

Daylight: Street light present	635472
Darkness: Street lights present and lit	172065
Darkeness: No street lighting	48736
Darkness: Street lighting unknown	7605
Darkness: Street lights present but unlit	3672

Length

Max length	41
Median length	30
Mean length	31.80168982
Min length	29

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Daylight: Street light present
2nd row	Daylight: Street light present
3rd row	Daylight: Street light present
4th row	Daylight: Street light present
5th row	Darkness: Street lights present and lit

Common Values

Value	Count	Frequency (%)
Daylight: Street light present	635472	73.2%
Darkness: Street lights present and lit	172065	19.8%
Darkeness: No street lighting	48736	5.6%
Darkness: Street lighting unknown	7605	0.9%
Darkness: Street lights present but unlit	3672	0.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
street	867550	22.7%
present	811209	21.2%
daylight	635472	16.6%
light	635472	16.6%
darkness	183342	4.8%
lights	175737	4.6%
and	172065	4.5%
lit	172065	4.5%
lighting	56341	1.5%
darkeness	48736	1.3%
Other values (4)	63685	1.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Weather_Conditions
Categorical

HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	107
Missing (%)	< 0.1%
Memory size	6.6 MiB

Fine without high winds	695558
Raining without high winds	98743
Other	21313
Unknown	16236
Fine with high winds	10860
Other values (4)	24733

Length

Max length	26
Median length	23
Mean length	22.52128612
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fine without high winds
2nd row	Fine without high winds
3rd row	Fine without high winds
4th row	Other
5th row	Fine without high winds

Common Values

Value	Count	Frequency (%)
Fine without high winds	695558	80.2%
Raining without high winds	98743	11.4%
Other	21313	2.5%
Unknown	16236	1.9%
Fine with high winds	10860	1.3%
Raining with high winds	10784	1.2%
Snowing without high winds	7928	0.9%
Fog or mist	4940	0.6%
Snowing with high winds	1081	0.1%
(Missing)	107	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
high	824954	24.6%
winds	824954	24.6%
without	802229	23.9%
fine	706418	21.1%
raining	109527	3.3%
with	22725	0.7%
other	21313	0.6%
unknown	16236	0.5%
snowing	9009	0.3%
fog	4940	0.1%
Other values (2)	9880	0.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Road_Surface_Conditions
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	1004
Missing (%)	0.1%
Memory size	6.6 MiB

Dry	598491
Wet/Damp	239197
Frost/Ice	20733
Snow	7149
Flood (Over 3cm of water)	976

Length

Max length	25
Median length	3
Mean length	4.556759826
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Dry
2nd row	Wet/Damp
3rd row	Dry
4th row	Frost/Ice
5th row	Dry

Common Values

Value	Count	Frequency (%)
Dry	598491	69.0%
Wet/Damp	239197	27.6%
Frost/Ice	20733	2.4%
Snow	7149	0.8%
Flood (Over 3cm of water)	976	0.1%
(Missing)	1004	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
dry	598491	68.8%
wet/damp	239197	27.5%
frost/ice	20733	2.4%
snow	7149	0.8%
flood	976	0.1%
over	976	0.1%
3cm	976	0.1%
of	976	0.1%
water	976	0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Special_Conditions_at_Site
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	13
Missing (%)	< 0.1%
Memory size	6.6 MiB

None	845879
Roadworks	10311
Ol or diesel	3107
Mud	2607
Road surface defective	2163
Other values (3)	3470

Length

Max length	47
Median length	4
Mean length	4.250086163
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	None
3rd row	None
4th row	None
5th row	None

Common Values

Value	Count	Frequency (%)
None	845879	97.5%
Roadworks	10311	1.2%
Ol or diesel	3107	0.4%
Mud	2607	0.3%
Road surface defective	2163	0.2%
Auto traffic singal out	1655	0.2%
Permanent sign or marking defective or obscured	1336	0.2%
Auto traffic signal partly defective	479	0.1%
(Missing)	13	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
none	845879	94.7%
roadworks	10311	1.2%
or	5779	0.6%
defective	3978	0.4%
ol	3107	0.3%
diesel	3107	0.3%
mud	2607	0.3%
road	2163	0.2%
surface	2163	0.2%
traffic	2134	0.2%
Other values (9)	11746	1.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Carriageway_Hazards
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	26
Missing (%)	< 0.1%
Memory size	6.6 MiB

None	851446
Other object in carriageway	7095
Any animal (except a ridden horse)	4686
Pedestrian in carriageway (not injured)	1952
Involvement with previous accident	1395

Length

Max length	39
Median length	4
Mean length	4.51328263
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	None
3rd row	None
4th row	None
5th row	None

Common Values

Value	Count	Frequency (%)
None	851446	98.1%
Other object in carriageway	7095	0.8%
Any animal (except a ridden horse)	4686	0.5%
Pedestrian in carriageway (not injured)	1952	0.2%
Involvement with previous accident	1395	0.2%
Dislodged vehicle load in carriageway	950	0.1%
(Missing)	26	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
none	851446	91.7%
in	9997	1.1%
carriageway	9997	1.1%
object	7095	0.8%
other	7095	0.8%
a	4686	0.5%
ridden	4686	0.5%
horse	4686	0.5%
except	4686	0.5%
animal	4686	0.5%
Other values (11)	18972	2.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Urban_or_Rural_Area
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.6 MiB

1	559614
2	307819
3	117

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	559614	64.5%
2	307819	35.5%
3	117	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	559614	64.5%
2	307819	35.5%
3	117	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Did_Police_Officer_Attend_Scene_of_Accident
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	2130
Missing (%)	0.2%
Memory size	1.7 MiB

True	699364
False	166056
(Missing)	2130

Common Values
Chart

Value	Count	Frequency (%)
True	699364	80.6%
False	166056	19.1%
(Missing)	2130	0.2%

LSOA_of_Accident_Location
Categorical

HIGH CARDINALITY
MISSING

Distinct	34140
Distinct (%)	4.2%
Missing	58613
Missing (%)	6.8%
Memory size	6.6 MiB

E01000004	1749
E01011365	921
E01004736	812
E01004764	702
E01008440	676
Other values (34135)	804077

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	580 ?
Unique (%)	0.1%

Sample

1st row	E01002882
2nd row	E01002886
3rd row	E01002912
4th row	E01002871
5th row	E01002840

Common Values

Value	Count	Frequency (%)
E01000004	1749	0.2%
E01011365	921	0.1%
E01004736	812	0.1%
E01004764	702	0.1%
E01008440	676	0.1%
E01005131	592	0.1%
E01002444	522	0.1%
E01001771	455	0.1%
E01018648	448	0.1%
E01023722	441	0.1%
Other values (34130)	801619	92.4%
(Missing)	58613	6.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
e01000004	1749	0.2%
e01011365	921	0.1%
e01004736	812	0.1%
e01004764	702	0.1%
e01008440	676	0.1%
e01005131	592	0.1%
e01002444	522	0.1%
e01001771	455	0.1%
e01018648	448	0.1%
e01023722	441	0.1%
Other values (34130)	801619	99.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Year
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2007.93322

Minimum	2005
Maximum	2011
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 MiB

Quantile statistics

Minimum	2005
5-th percentile	2005
Q1	2006
median	2009
Q3	2010
95-th percentile	2011
Maximum	2011
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.326594241
Coefficient of variation (CV)	0.001158701005
Kurtosis	-1.670757708
Mean	2007.93322
Median Absolute Deviation (MAD)	2
Skewness	-0.04206633452
Sum	1741982465
Variance	5.413040762
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2005	198735	22.9%
2006	189161	21.8%
2009	163554	18.9%
2010	154414	17.8%
2011	151474	17.5%
2007	10212	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2005	198735	22.9%
2006	189161	21.8%
2007	10212	1.2%
2009	163554	18.9%
2010	154414	17.8%
2011	151474	17.5%

Value	Count	Frequency (%)
2011	151474	17.5%
2010	154414	17.8%
2009	163554	18.9%
2007	10212	1.2%
2006	189161	21.8%
2005	198735	22.9%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Accident_Index	Location_Easting_OSGR	Location_Northing_OSGR	Longitude	Latitude	Police_Force	Accident_Severity	Number_of_Vehicles	Number_of_Casualties	Date	Day_of_Week	Time	Local_Authority_(District)	Local_Authority_(Highway)	1st_Road_Class	1st_Road_Number	Road_Type	Speed_limit	Junction_Detail	Junction_Control	2nd_Road_Class	2nd_Road_Number	Pedestrian_Crossing-Human_Control	Pedestrian_Crossing-Physical_Facilities	Light_Conditions	Weather_Conditions	Road_Surface_Conditions	Special_Conditions_at_Site	Carriageway_Hazards	Urban_or_Rural_Area	Did_Police_Officer_Attend_Scene_of_Accident	LSOA_of_Accident_Location	Year
0	200901BS70001	524910.0	180800.0	-0.201349	51.512273	1	2	2	1	1/1/2009	5	15:11	12	E09000020	6	0	One way street	30	NaN	Giveway or uncontrolled	6	0	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine without high winds	Dry	None	None	1	Yes	E01002882	2009
1	200901BS70002	525050.0	181040.0	-0.199248	51.514399	1	2	2	11	5/1/2009	2	10:59	12	E09000020	5	0	Single carriageway	30	NaN	Giveway or uncontrolled	5	0	None within 50 metres	Zebra crossing	Daylight: Street light present	Fine without high winds	Wet/Damp	None	None	1	Yes	E01002886	2009
2	200901BS70003	526490.0	177990.0	-0.179599	51.486668	1	3	2	1	4/1/2009	1	14:19	12	E09000020	3	308	Single carriageway	30	NaN	Giveway or uncontrolled	6	0	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine without high winds	Dry	None	None	1	Yes	E01002912	2009
3	200901BS70004	524800.0	180300.0	-0.203110	51.507804	1	2	2	1	5/1/2009	2	8:10	12	E09000020	3	402	Single carriageway	30	NaN	Automatic traffic signal	4	450	None within 50 metres	Pedestrian phase at traffic signal junction	Daylight: Street light present	Other	Frost/Ice	None	None	1	Yes	E01002871	2009
4	200901BS70005	526930.0	177490.0	-0.173445	51.482076	1	2	2	1	6/1/2009	3	17:25	12	E09000020	3	3212	Single carriageway	30	NaN	Automatic traffic signal	3	3220	None within 50 metres	No physical crossing within 50 meters	Darkness: Street lights present and lit	Fine without high winds	Dry	None	None	1	Yes	E01002840	2009
5	200901BS70006	526060.0	178730.0	-0.185525	51.493415	1	3	2	3	1/1/2009	5	11:48	12	E09000020	6	0	Single carriageway	30	NaN	Giveway or uncontrolled	6	0	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine without high winds	Dry	None	None	1	Yes	E01002839	2009
6	200901BS70007	526580.0	177270.0	-0.178561	51.480177	1	2	2	1	8/1/2009	5	13:58	12	E09000020	3	3220	Single carriageway	30	NaN	Giveway or uncontrolled	3	3220	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine without high winds	Dry	None	None	1	Yes	E01002841	2009
7	200901BS70008	526550.0	178580.0	-0.178524	51.491957	1	3	1	1	2/1/2009	6	13:18	12	E09000020	5	0	Dual carriageway	30	NaN	Automatic traffic signal	3	3218	None within 50 metres	Pedestrian phase at traffic signal junction	Daylight: Street light present	Fine without high winds	Dry	None	None	1	Yes	E01002835	2009
8	200901BS70009	527310.0	179100.0	-0.167395	51.496460	1	3	1	2	7/1/2009	4	12:15	12	E09000020	6	0	Single carriageway	30	NaN	Giveway or uncontrolled	6	0	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine without high winds	Dry	None	None	1	Yes	E01002819	2009
9	200901BS70010	526250.0	177370.0	-0.183275	51.481150	1	3	1	1	10/1/2009	7	9:52	12	E09000020	3	308	Single carriageway	30	NaN	Automatic traffic signal	3	3220	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Other	Wet/Damp	Roadworks	None	1	Yes	E01002843	2009

Last rows

	Accident_Index	Location_Easting_OSGR	Location_Northing_OSGR	Longitude	Latitude	Police_Force	Accident_Severity	Number_of_Vehicles	Number_of_Casualties	Date	Day_of_Week	Time	Local_Authority_(District)	Local_Authority_(Highway)	1st_Road_Class	1st_Road_Number	Road_Type	Speed_limit	Junction_Detail	Junction_Control	2nd_Road_Class	2nd_Road_Number	Pedestrian_Crossing-Human_Control	Pedestrian_Crossing-Physical_Facilities	Light_Conditions	Weather_Conditions	Road_Surface_Conditions	Special_Conditions_at_Site	Carriageway_Hazards	Urban_or_Rural_Area	Did_Police_Officer_Attend_Scene_of_Accident	LSOA_of_Accident_Location	Year
867540	200701MD68578	533950.0	171420.0	-0.074704	51.425910	1	2	2	1	31/12/2007	2	1:15	8	E09000028	3	212	Dual carriageway	30	NaN	Giveway or uncontrolled	6	0	None within 50 metres	No physical crossing within 50 meters	Darkness: Street lights present and lit	Fine without high winds	Wet/Damp	None	None	1	Yes	E01003948	2007
867541	200701MD68647	532660.0	180170.0	-0.089967	51.504847	1	3	2	1	15/12/2007	7	13:40	8	E09000028	3	3	Single carriageway	30	NaN	Automatic traffic signal	3	3200	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine without high winds	Dry	None	None	1	Yes	E01003929	2007
867542	200701MD68794	534840.0	177530.0	-0.059583	51.480607	1	2	2	1	12/7/2007	5	8:29	8	E09000028	3	2	Single carriageway	30	NaN	Giveway or uncontrolled	6	0	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Other	Dry	None	None	1	Yes	E01003988	2007
867543	200701MD68800	532460.0	176980.0	-0.094043	51.476226	1	3	2	1	5/7/2007	5	0:01	8	E09000028	3	215	Single carriageway	30	NaN	Automatic traffic signal	6	0	None within 50 metres	Pedestrian phase at traffic signal junction	Darkness: Street lights present and lit	Raining without high winds	Wet/Damp	None	None	1	No	E01003921	2007
867544	200701MD68803	535180.0	177340.0	-0.054762	51.478818	1	3	1	1	20/07/2007	6	12:30	8	E09000028	5	0	Dual carriageway	30	NaN	Giveway or uncontrolled	3	2	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Raining without high winds	Wet/Damp	None	None	1	Yes	E01003984	2007
867545	200701MD68807	531780.0	178620.0	-0.103217	51.491123	1	2	2	1	11/5/2007	6	7:53	8	E09000028	3	3	Single carriageway	30	NaN	Automatic traffic signal	3	3204	None within 50 metres	Pedestrian phase at traffic signal junction	Daylight: Street light present	Fine without high winds	Dry	None	None	1	No	E01003110	2007
867546	200701MD68808	532110.0	177000.0	-0.099072	51.476488	1	3	2	1	15/05/2007	3	9:00	8	E09000028	3	202	Single carriageway	30	NaN	Giveway or uncontrolled	6	0	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine without high winds	Dry	None	None	1	Yes	E01003919	2007
867547	200701MD68812	532390.0	173070.0	-0.096513	51.441104	1	3	2	1	17/05/2007	5	20:55	9	E09000022	5	0	Single carriageway	30	NaN	Giveway or uncontrolled	6	0	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Unknown	Dry	None	None	1	No	E01003170	2007
867548	200701MD68824	531950.0	180250.0	-0.100161	51.505732	1	3	2	1	8/5/2007	3	17:50	8	E09000028	3	3200	Single carriageway	30	NaN	NaN	-1	0	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine with high winds	Dry	None	None	1	Yes	E01003927	2007
867549	200701MD68851	533630.0	179100.0	-0.076404	51.495003	1	2	1	1	14/11/2007	4	10:45	8	E09000028	3	2206	Single carriageway	30	NaN	Giveway or uncontrolled	5	0	None within 50 metres	Zebra crossing	Daylight: Street light present	Fine without high winds	Dry	None	None	1	Yes	E01003978	2007

Most frequently occurring

	Accident_Index	Location_Easting_OSGR	Location_Northing_OSGR	Longitude	Latitude	Police_Force	Accident_Severity	Number_of_Vehicles	Number_of_Casualties	Date	Day_of_Week	Time	Local_Authority_(District)	Local_Authority_(Highway)	1st_Road_Class	1st_Road_Number	Road_Type	Speed_limit	Junction_Control	2nd_Road_Class	2nd_Road_Number	Pedestrian_Crossing-Human_Control	Pedestrian_Crossing-Physical_Facilities	Light_Conditions	Weather_Conditions	Road_Surface_Conditions	Special_Conditions_at_Site	Carriageway_Hazards	Urban_or_Rural_Area	Did_Police_Officer_Attend_Scene_of_Accident	LSOA_of_Accident_Location	Year	# duplicates
0	2.0111E+12	429320.0	557990.0	-1.544135	54.915778	10	3	1	1	18/01/2011	3	8:25	150	E08000024	2	194	Dual carriageway	70	Giveway or uncontrolled	3	182	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine without high winds	Frost/Ice	None	None	2	Yes	E01008873	2011	2
1	2.01E+12	503250.0	487860.0	-0.415801	54.275973	12	3	2	1	4/2/2005	6	13:40	186	E10000023	6	0	Single carriageway	30	Giveway or uncontrolled	3	64	None within 50 metres	No physical crossing within 50 meters	Daylight: Street light present	Fine without high winds	Wet/Damp	None	None	1	Yes	E01027826	2005	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length